CREATE    VIEW [dbo].[vWorkflowInstanceReport]
AS
SELECT    wfi.WorkflowInstanceKey,
    wfi.ProcessName,
    wfi.WorkflowStatus,
    wfi.InitiatedByUserKey,
    cm2.FullName InitiatedByName,
    wfi.InitiatedOn,
    wfi.LogText,
    CASE WHEN wfi.LockedByUserKey IS NULL THEN 'No' WHEN wfi.KeepAlive IS NULL THEN 'No' WHEN wfi.KeepAlive < dateadd(mi, - dbo.asi_GetWorkflowInstanceLockDuration(), getdate()) THEN 'No' ELSE 'Yes' END IsLocked,
    COALESCE (cm.FullName, '') LockedByName
FROM    WorkflowInstance wfi
    INNER JOIN ContactMain cm2 ON wfi.InitiatedByUserKey = cm2.ContactKey
    LEFT OUTER JOIN ContactMain cm ON wfi.LockedByUserKey = cm.ContactKey

GO